Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_APPLY_ERROR

`ALL_APPLY_ERROR` displays information about error transactions generated by the apply processes that dequeue events from queues accessible to the current user.

Related View

`DBA_APPLY_ERROR` displays information about error transactions generated by all apply processes in the database.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`APPLY_NAME` | `VARCHAR2(30)` |  | Name of the apply process at the local database which processed the transaction
`QUEUE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the queue at the local database from which the transaction was dequeued
`QUEUE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the queue at the local database from which the transaction was dequeued
`LOCAL_TRANSACTION_ID` | `VARCHAR2(22)` |  | Local transaction ID for the error transaction
`SOURCE_DATABASE` | `VARCHAR2(128)` |  | Database where the transaction originated
`SOURCE_TRANSACTION_ID` | `VARCHAR2(22)` |  | Original transaction ID at the source database
`SOURCE_COMMIT_SCN` | `NUMBER` |  | Original commit system change number (SCN) for the transaction at the source database
`MESSAGE_NUMBER` | `NUMBER` |  | Identifier for the event in the transaction that raised an error
`ERROR_NUMBER` | `NUMBER` |  | Error number of the error raised by the transaction
`ERROR_MESSAGE` | `VARCHAR2(4000)` |  | Error message of the error raised by the transaction
`RECIPIENT_ID` | `NUMBER` |  | User ID of the original user that applied the transaction
`RECIPIENT_NAME` | `VARCHAR2(30)` |  | Name of the original user that applied the transaction
`MESSAGE_COUNT` | `NUMBER` |  | Total number of events inside the error transaction
`ERROR_CREATION_TIME` | `DATE` |  | Time that this error was created

See Also: "DBA_APPLY_ERROR"